Stored Procedures [dbo].[BAECartEventGetAllForUser]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@Idvarchar(32)32
SQL Script
create procedure [dbo].[BAECartEventGetAllForUser] @Id varchar(32) as
SELECT *
    FROM CartEvent ce
    INNER JOIN CartItem ci on ci.CartItemID = ce.CartItemID
    WHERE ci.UserID = @Id ORDER BY ce.Title

GO
Uses